package com.nbjtjc.safe.mapper.sys;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.nbjtjc.safe.model.sys.SysUserReport;
import com.nbjtjc.util.MyMapper;

public interface SysUserReportMapper extends MyMapper<SysUserReport> {
	@Select("select * from sys_user_report where year = #{year}")
	List<SysUserReport> searchByYear(@Param("year") String year);
	
	@Delete("delete from sys_user_report where year = #{year}")
	int deleteByYear(@Param("year") String year);
}